
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vw_EShopGoods]') and xtype='V')
Drop view [dbo].[vw_EShopGoods]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TU_History_Price]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TU_History_Price]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TI_History_Price]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TI_History_Price]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sp_OnlineProductTracking]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Sp_OnlineProductTracking]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EShop_FactorInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[EShop_FactorInsert]
